Code Example: Using Excel Formulas

from ironxl import * # Load the Excel workbook workbook = WorkBook.Load("sample.xlsx") worksheet = workbook.DefaultWorkSheet # Set Formulas worksheet["A1"].Formula = "Sum(B8:C12)" worksheet["B8"].Formula = "=C9/C11" worksheet["G30"].Formula = "Max(C3:C7)" # Force recalculate all formula values in all sheets. workbook.EvaluateAll() # Get the formula's calculated value. e.g. "52" formula_value = worksheet["G30"].ToArray()[0].FormattedCellValue # Get the formula as a string. e.g. "Max(C3:C7)" formula_string = worksheet["G30"].Formula # Save changes with updated formulas and calculated values. workbook.Save()

Excel Formulas in C#

Using IronXL to Work with Excel Formulas in Python

IronXL for Python allows setting and evaluating Excel formulas without the need for Office Interop or a licensed Excel installation. It supports over 150+ formulas, with more being added regularly. Formulas are assigned using the Range.Formula property.

A formula is an expression used to calculate the value of a cell. In Excel, functions are predefined formulas that are always available for use.

IronXL distinguishes itself among Python Excel libraries by supporting a wide range of built-in Excel formulas and enabling their real-time calculation in Python applications.

How to Use Excel Formulas in Python

Here are the steps to work with Excel formulas using IronXL in a Python project:

Install IronXL for Python: Install IronXL via pip to access Excel functionality.
Load the Excel Document: Open your Excel file and select the WorkSheet where you want to apply formulas.
Set Formulas and Values: Assign formula strings and any required values to the target cells.
Evaluate Formulas: Use the EvaluateAll method to compute the results of all applied formulas.
Save the WorkBook: Save the WorkBook back to an Excel file, reflecting all changes and calculations.

IronXL provides a straightforward and efficient method for working with Excel formulas programmatically in Python, without requiring Excel to be installed on the server or client machine.

Learn to Edit Excel Formulas in Python with IronXL